Skip to main content

DB2

Samples Overview​

Qarbine provides a wide variety of sample templates, and queries. Some are application oriented examples, while others are database administrator (DBA) oriented.

Below are a few of the component samples to consider. Review the Qarbine Catalog for the latest components. See the latest set of IBM DB2 components in the folder depicted below.

  

  

List Tablespace Summary​

This template is at “example/IBM/DB2/DBA/List tablespace summary”.

The result is shown below.

  

List Tables​

This template is at “example/IBM/DB2/DBA/List tables”.

The result is shown below.

  

Describe Table​

This template is at “example/IBM/DB2/DBA/List tablespace summary”.

Running it presents a prompt for which table.

  

Choose a table and click OK. Sample results are shown below.

  

List Table Indexes​

This template is at “example/IBM/DB2/DBA/Describe prompted table indexes using SQL”.

The result is shown below.

  

Database Settings​

This template is at “example/IBM/DB2/DBA/List database configuration settings”.

The result is shown below.